/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package NativeQuery;

/**
 *
 * @author Antonio
 */
public class NativeQuery {

    public static String MARCHI_PRODOTTI_NON_INVENDITA = "SELECT * FROM MARCHIO m WHERE EXISTS(SELECT p.codiceBarre FROM PRODOTTO p WHERE p.marchio_id = m.id AND (p.codiceBarre) NOT IN (SELECT dp.prodotto FROM DETTAGLIOPREZZO dp WHERE dp.negozio = ?1))";
}
